inherited fmYTS: TfmYTS
  Caption = 'YTS Listesi'
  ClientHeight = 548
  ClientWidth = 774
  OnClose = FormClose
  ExplicitWidth = 782
  ExplicitHeight = 575
  PixelsPerInch = 96
  TextHeight = 13
  inherited grpTop: TcxGroupBox
    ExplicitWidth = 774
    Width = 774
    object Label7: TLabel
      Left = 15
      Top = 21
      Width = 54
      Height = 13
      Caption = 'YTS '#220'nvan'#305
    end
    object edYTS: TcxTextEdit
      Left = 75
      Top = 19
      TabOrder = 0
      Width = 238
    end
    object cbHesapla: TcxCheckBox
      Left = 344
      Top = 16
      Caption = 'Alan-Personel Hesapla'
      TabOrder = 1
      Width = 137
    end
  end
  inherited PC: TcxPageControl
    Width = 774
    Height = 434
    ExplicitWidth = 774
    ExplicitHeight = 434
    ClientRectBottom = 434
    ClientRectRight = 774
    inherited TS1: TcxTabSheet
      ExplicitTop = 24
      ExplicitWidth = 774
      ExplicitHeight = 410
      inherited cxReport: TcxGrid
        Width = 774
        Height = 410
        ExplicitTop = -6
        ExplicitWidth = 774
        ExplicitHeight = 410
        inherited grdReport: TcxGridDBTableView
          object grdReportID: TcxGridDBColumn
            DataBinding.FieldName = 'ID'
          end
          object grdReportsFirmaAdi: TcxGridDBColumn
            Caption = 'Firma Ad'#305
            DataBinding.FieldName = 'sFirmaAdi'
            Width = 217
          end
          object grdReportsFirmaAdres: TcxGridDBColumn
            Caption = 'Firma Adres'
            DataBinding.FieldName = 'sFirmaAdres'
            Width = 200
          end
          object grdReportsTelefon: TcxGridDBColumn
            Caption = 'Telefon'
            DataBinding.FieldName = 'sTelefon'
            Width = 121
          end
          object grdReportsFax: TcxGridDBColumn
            Caption = 'Fax'
            DataBinding.FieldName = 'sFax'
            Width = 99
          end
          object grdReportsEmail: TcxGridDBColumn
            Caption = 'Email'
            DataBinding.FieldName = 'sEmail'
            Width = 152
          end
          object grdReportsBelgeNo: TcxGridDBColumn
            Caption = 'BelgeNo'
            DataBinding.FieldName = 'sBelgeNo'
            Width = 100
          end
          object grdReportsBelgeVYer: TcxGridDBColumn
            Caption = 'Belge Verilen Yer'
            DataBinding.FieldName = 'sBelgeVYer'
            Width = 100
          end
          object grdReportsFirmaIL: TcxGridDBColumn
            Caption = 'Firma '#304'l'
            DataBinding.FieldName = 'sFirmaIL'
            Width = 130
          end
          object grdReportnServisAlani: TcxGridDBColumn
            Caption = 'T.Servis Alan'#305
            DataBinding.FieldName = 'nServisAlani'
            Width = 98
          end
          object grdReportnPersonelSayisi: TcxGridDBColumn
            Caption = 'T.Personel Say'#305's'#305
            DataBinding.FieldName = 'nPersonelSayisi'
            Width = 112
          end
          object grdReportnIdariAlan: TcxGridDBColumn
            Caption = #304'dari Alan'
            DataBinding.FieldName = 'nIdariAlan'
          end
          object grdReportnIdariPersonelSayisi: TcxGridDBColumn
            Caption = #304'dari Personel Say'#305's'#305
            DataBinding.FieldName = 'nIdariPersonelSayisi'
            Width = 85
          end
          object grdReportnFiyat: TcxGridDBColumn
            Caption = 'Fiyat'
            DataBinding.FieldName = 'nFiyat'
            Width = 77
          end
          object grdReportnStatuID: TcxGridDBColumn
            Caption = 'Stat'#252
            DataBinding.FieldName = 'nStatuID'
            PropertiesClassName = 'TcxLookupComboBoxProperties'
            Properties.KeyFieldNames = 'ID'
            Properties.ListColumns = <
              item
                FieldName = 'sStatu'
              end>
            Properties.ListSource = dsStatu
            Width = 100
          end
          object grdReportbState: TcxGridDBColumn
            Caption = 'Durum'
            DataBinding.FieldName = 'bState'
            Width = 60
          end
          object grdReportnTopServisAlani: TcxGridDBColumn
            Caption = 'Top.Servis Alan'#305
            DataBinding.FieldName = 'nTopServisAlani'
            Width = 95
          end
          object grdReportnTopPersonelSayisi: TcxGridDBColumn
            Caption = 'Top.Personel Say'#305's'#305
            DataBinding.FieldName = 'nTopPersonelSayisi'
            Width = 106
          end
          object grdReportKapasite: TcxGridDBColumn
            DataBinding.FieldName = 'Kapasite'
          end
          object grdReportKullanilanKapasite: TcxGridDBColumn
            Caption = 'Kullan'#305'lan Kapasite'
            DataBinding.FieldName = 'KullanilanKapasite'
            Width = 90
          end
          object grdReportKapasiteOran: TcxGridDBColumn
            Caption = 'Kapasite Oran'
            DataBinding.FieldName = 'KapasiteOran'
          end
          object grdReportKullanilanServisAlani: TcxGridDBColumn
            Caption = 'Kullan'#305'lan Servis Alan'#305
            DataBinding.FieldName = 'KullanilanServisAlani'
            Width = 93
          end
          object grdReportGerekliPersonelSayisi: TcxGridDBColumn
            Caption = 'Gerekli Personel Say'#305's'#305
            DataBinding.FieldName = 'GerekliPersonelSayisi'
          end
          object grdReportEksikPersonelSayisi: TcxGridDBColumn
            Caption = 'Eksik Personel Say'#305's'#305
            DataBinding.FieldName = 'EksikPersonelSayisi'
          end
          object grdReportEksikAlan: TcxGridDBColumn
            Caption = 'Eksik Alan'
            DataBinding.FieldName = 'EksikAlan'
          end
        end
      end
    end
    inherited TSEdit: TcxTabSheet
      ExplicitTop = 18
      ExplicitWidth = 774
      ExplicitHeight = 410
      object Label1: TLabel
        Left = 36
        Top = 13
        Width = 44
        Height = 13
        Alignment = taRightJustify
        Caption = 'Firma Ad'#305
      end
      object Label2: TLabel
        Left = 23
        Top = 34
        Width = 57
        Height = 13
        Alignment = taRightJustify
        Caption = 'Firma Adres'
      end
      object Label3: TLabel
        Left = 13
        Top = 55
        Width = 65
        Height = 13
        Alignment = taRightJustify
        Caption = 'T.Servis Alan'#305
      end
      object Label4: TLabel
        Left = 2
        Top = 76
        Width = 76
        Height = 13
        Alignment = taRightJustify
        Caption = 'T.Personel Say.'
      end
      object Label5: TLabel
        Left = 52
        Top = 97
        Width = 26
        Height = 13
        Alignment = taRightJustify
        Caption = 'Fiyat'#305
      end
      object Label6: TLabel
        Left = 52
        Top = 119
        Width = 26
        Height = 13
        Alignment = taRightJustify
        Caption = 'Stat'#252
      end
      object Label8: TLabel
        Left = 216
        Top = 54
        Width = 63
        Height = 13
        Alignment = taRightJustify
        Caption = #304'.Servis Alan'#305
      end
      object Label9: TLabel
        Left = 207
        Top = 76
        Width = 74
        Height = 13
        Alignment = taRightJustify
        Caption = #304'.Personel Say.'
      end
      object edFirmaAdi: TcxDBTextEdit
        Left = 84
        Top = 10
        DataBinding.DataField = 'sFirmaAdi'
        DataBinding.DataSource = dsList
        Properties.ReadOnly = True
        Style.Color = clSkyBlue
        TabOrder = 0
        Width = 185
      end
      object edFirmaAdres: TcxDBTextEdit
        Left = 84
        Top = 31
        DataBinding.DataField = 'sFirmaAdres'
        DataBinding.DataSource = dsList
        Properties.ReadOnly = True
        Style.Color = clSkyBlue
        TabOrder = 1
        Width = 310
      end
      object edServisAlan: TcxDBSpinEdit
        Left = 84
        Top = 53
        DataBinding.DataField = 'nServisAlani'
        DataBinding.DataSource = dsList
        Properties.SpinButtons.Visible = False
        TabOrder = 2
        Width = 121
      end
      object edPersonelSayisi: TcxDBSpinEdit
        Left = 84
        Top = 73
        DataBinding.DataField = 'nPersonelSayisi'
        DataBinding.DataSource = dsList
        Properties.SpinButtons.Visible = False
        TabOrder = 3
        Width = 121
      end
      object edFiyat: TcxDBSpinEdit
        Left = 84
        Top = 94
        DataBinding.DataField = 'nFiyat'
        DataBinding.DataSource = dsList
        Properties.SpinButtons.Visible = False
        TabOrder = 4
        Width = 121
      end
      object cbState: TcxDBCheckBox
        Left = 43
        Top = 134
        Caption = 'Durum'
        DataBinding.DataField = 'bState'
        DataBinding.DataSource = dsList
        Properties.Alignment = taRightJustify
        Properties.ImmediatePost = True
        Properties.NullStyle = nssUnchecked
        TabOrder = 6
        Width = 58
      end
      object lcStatu: TcxDBLookupComboBox
        Left = 84
        Top = 116
        DataBinding.DataField = 'nStatuID'
        DataBinding.DataSource = dsList
        Properties.ImmediateDropDownWhenActivated = True
        Properties.ImmediatePost = True
        Properties.KeyFieldNames = 'ID'
        Properties.ListColumns = <
          item
            FieldName = 'sStatu'
          end>
        Properties.ListSource = dsStatu
        Properties.PostPopupValueOnTab = True
        TabOrder = 5
        Width = 121
      end
      object ediServisAlan: TcxDBSpinEdit
        Left = 287
        Top = 52
        DataBinding.DataField = 'nIdariAlan'
        DataBinding.DataSource = dsList
        Properties.SpinButtons.Visible = False
        TabOrder = 7
        Width = 121
      end
      object ediPersonelSayisi: TcxDBSpinEdit
        Left = 287
        Top = 73
        DataBinding.DataField = 'nIdariPersonelSayisi'
        DataBinding.DataSource = dsList
        Properties.SpinButtons.Visible = False
        TabOrder = 8
        Width = 121
      end
    end
  end
  inherited grpButtons: TcxGroupBox
    ExplicitWidth = 774
    Width = 774
    inherited btClose: TcxButton
      Left = 715
      ExplicitLeft = 715
    end
    inherited btNew: TcxButton
      ExplicitLeft = -4
      ExplicitTop = 3
    end
  end
  inherited HBottom: TcxHeader
    Top = 531
    Width = 774
    ExplicitLeft = 32
    ExplicitTop = 537
    ExplicitWidth = 774
  end
  inherited aqList: TADOQuery
    SQL.Strings = (
      
        'SELECT TOP 10 Y.ID,Y.sFirmaAdi,Y.sFirmaAdres,Y.sTelefon,Y.sFax,Y' +
        '.sEmail,Y.sBelgeNo,Y.sBelgeVYer,Y.sFirmaIL,Y.nServisAlani,'
      
        'Y.nPersonelSayisi,Y.nStatuID,Y.nFiyat,Y.bState,Y.nIdariAlan,Y.nI' +
        'dariPersonelSayisi'
      ',nTopServisAlani=Y2.nServisAlani'
      ',nTopPersonelSayisi=Y2.nPersonelSayisi'
      
        ',Y2.Kapasite,Y2.KullanilanKapasite,Y2.KapasiteOran,Y2.Kullanilan' +
        'ServisAlani,Y2.GerekliPersonelSayisi'
      ',Y2.EksikPersonelSayisi,Y2.EksikAlan'
      'FROM tbYTS Y WITH(NOLOCK)'
      'LEFT JOIN WW_YTS_DETAY Y2 WITH(NOLOCK) ON (Y.ID=Y2.ID)')
  end
  object aqStatu: TADOQuery
    Connection = DM.Connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'SELECT * FROM tbYTSStatu')
    Left = 280
    Top = 240
  end
  object dsStatu: TDataSource
    DataSet = aqStatu
    Left = 336
    Top = 240
  end
end
